package cn.usian.jyzx.product.mapper;

import cn.usian.jyzx.model.dto.h5.ProductSkuDto;
import cn.usian.jyzx.model.entity.product.ProductSku;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProductSkuMapper {
    @Select("select * from product_sku order by sale_num desc limit 10 ")
    List<ProductSku> findSku();

    List<ProductSku> findpage(ProductSkuDto productSkuDto);
@Select("select * from product_sku where id = #{skuId}")
    ProductSku item(Long skuId);
@Select("select * from product_sku where id = #{id}")
    List<ProductSku> getall(Long id);
    @Select("select * from product_sku where id = #{skuId}")
    ProductSku getBySkuId(Integer skuId);
}
